Strange Problem. Please Help.

--0-1233552616-1172495202=:54509
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Dear all,
=20
I have a very strange problem with Access 2003 as frontend and PqSql 8.=
1 as backend.
=20
In my access application, i have order form with orderdetail subform.
=20
Subform recordsource, based on a saved Access query that has very simpl=
e calculated field "AMOUNT" that calculate QTY*Unitprice. At the form foo=
ter, i have SUBTOTAL Textbox with "=3Dsum(amount)" function. All fields h=
as "standard" format, with 2 decimals
=20
The problem is : when subtotal should have decimals value eg. 123.45
=20
It just show 123.00
=20
What caused this problem ? I didn't experience the same problem with MD=
B tables database.
=20
I remember when i installed PostgreSQL, i check all function, and my da=
tabase has about 500 fundred built in function !! Is this the source of p=
roblem ?
=20
Thank you for any help !

=20
---------------------------------
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
--0-1233552616-1172495202=:54509
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable